package register;

import java.sql.*;

public class Search {
	/**
	 * @查询全部
	 *
	 */
	public static void searchAll() {
		Connection con = null;
		ResultSet rs = null;
		PreparedStatement ps = null;
		try {
			con = JdbcTools.getConn();
			String sql = "select * from emp limit 10 offset 0";
			ps.executeQuery(sql);

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			JdbcTools.close(rs, ps, con);
		}
	}
	/**
	 * @模糊查询
	 * 
	 */
	public static void searchDim(String a, String b) {
		Connection con = null;
		ResultSet rs = null;
		PreparedStatement ps = null;
		try {
			con = JdbcTools.getConn();
			String sql = "select * from emp limit 10 offset 0";
			ps.executeQuery(sql);

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			JdbcTools.close(rs, ps, con);
		}
	}
	
	/**
	 * @按姓查询
	 *
	 */
	public void searchName(){
		
	}
		/**
		 * @按工资查询
		 *
		 */
	public void searchSalary(){
		
	}
	
	public void searchAge(){
		
	}
	
	
	
}
